﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace 图书借阅系统
{
    public partial class 借阅逾期查询 : System.Web.UI.Page
    {
        private void BindGridView1()
        {
            string str = @"select 书名,姓名,还书时间
                            from 借阅,图书,用户
                            where 还书时间 <
                            (select GETDATE()) and 图书id=图书.id and 用户id=用户.id";
            GridView1.DataSource = Connection.getData(str);
            GridView1.DataBind();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            BindGridView1();
        }


    }
}